SSIS: Can not execute dataflow in Visual Studio

Categories: Database; Tagged with: SQL • SQL Server • SSIS; @ September 6th, 2012 19:24

This happened when we just edit the dtsx file.
If you want execute the flow in VS directly, create one Integration services project first, then you can copy your dtsx and pase it into the “SSIS Packages” in the Solution Explorer:

then you can execute the ssis dataflow directly in VS.

SQL Server: Execute SQL Agent job from T-SQL <-> Using function in SQL Server 在SQL Server中使用函数